USE [texchange_db]
GO

/****** Object:  StoredProcedure [dbo].[SP_GetUser]    Script Date: 05/29/2011 19:46:45 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE proc [dbo].[SP_GetUser] 
  @username    varchar(255) = '',
  @password    varchar(255) = ''
as

  SELECT TOP 1
   		 [id], [Name], [username],[password],[isActive],[lastLogin],[userType],[company_id]
  FROM [dbo].[Users]
  WHERE [username]=@username AND [password] = @password
return


GO


